/****** Object:  Stored Procedure dbo.asi_ExportTypeByKey    Script Date: 7/3/2003 4:58:03 PM ******/
CREATE   PROC [dbo].[asi_ExportTypeByKey]
    @typeKey uniqueidentifier
    AS
BEGIN
    SET ROWCOUNT 1
    SELECT    e.Name as ExportTypeName ,e.ExportType, e.NavMarker, e.ProcessEngineTypeKey, p.Name

     FROM    ExportType e, ProcessEngineType p
            
     WHERE    e.ExportTypeKey = @typeKey
        and e.ProcessEngineTypeKey = p.ProcessEngineTypeKey
    SET ROWCOUNT 0
END

GO